Tiny File Manager | hub_tktsts

Back Back Up Advanced Editor

<?php
//======================================================================================
//
// Function: Maintain  HUB_TKTSTS
//
// Programmer: JKJ
// Date      : 2025-01-13
//
// https://datatables.net/plug-ins/sorting/natural
// <script src="https://cdn.datatables.net/plug-ins/2.2.1/sorting/natural.min.js"></script>
//
// Copyright Reeft A/S (c) - 2025
//======================================================================================

//======================================================================================
// Get input
//======================================================================================

if (isset($_REQUEST["LASTCALLED"])) {
		$LASTCALLED = $_REQUEST["LASTCALLED"];
	} else {
		$LASTCALLED = '';
	}

//======================================================================================
// Make line uppercase
//======================================================================================

//======================================================================================
// General config
//======================================================================================
	include "config/config.php";

//======================================================================================
// Check if user is logged in?
//======================================================================================
	include "login_check.php";

//======================================================================================
// Get session variables
//======================================================================================

include "include/getsession.php";

// include "include/uuid_create.php";
	// include "include/generate_password_md5.php";

//======================================================================================
// Set language
//======================================================================================

include "include/set_language.php";

//======================================================================================
// Set defaults
//======================================================================================

// $pk_reference  = $_SESSION['session_dft_pk_reference'];
	// $referenceCode = $_SESSION['session_dft_referencecode'];
	// $referenceName = $_SESSION['session_dft_referencename'];

//======================================================================================
?>
<!DOCTYPE html>
<html lang="en">
<head>
	<title><?php echo $datahub_text0001 ?></title>

<link href="css/bootstrap4.3.1/css/bootstrap.custom.min.css" rel="stylesheet">
    <link href="css/bootstrap4.3.1/css/themes/bootstrap.custom.min.css" rel="stylesheet">

<link href="css/custom.css" rel="stylesheet">
    <link href="css/style.css" rel="stylesheet">

<link href="javascript/datatables.3.12/datatables.min.css" rel="stylesheet">
		<script src="javascript/datatables.3.12/datatables.min.js"></script>

.btn-custom-wide {
	height:60px;
	width:210px;
}

.text-truncate-dt {
    max-width: 450px;
	white-space: nowrap;
    overflow: hidden;
	text-overflow: ellipsis;

}

.overflow-class {
	width: 100%;
	/*height:700px;*/
	max-height: calc(100vh - 283px);
	overflow-y: scroll;
	overflow-x: scroll;
}

.overflow-class-modal-body {
	width: 99%;
	max-height: calc(100vh - 283px);
	overflow-y: scroll;
	overflow-x: hidden;
}

.text-align-center-dt {
    text-align: center;
}

.text-align-left-dt {
    text-align: left;
}

.text-align-right-dt {
    text-align: right;
}

.modal-xxl {
    max-width: 80%;
}

.modal-xl {
    max-width: 50%;
}

.border-3 {
    border-width:3px !important;
}

td .hover-img {
  position:relative;
 }
td .hover-img span {
  position:absolute; left:-9999px; top:-9999px; z-index:9999;
 }
td:hover .hover-img span {
  top: 5px;
  left:0px;
 }

.chosen-container-single {
    min-width: 100%;
}

</style>

//=============================================================================
// Globals
//=============================================================================

var thisCurrentRow;
	var thisGlobalRowData;
    var thisGlobalTableData;

// date variables
	var input_fromdate;
	var input_fromtime;
	var input_todate;
	var input_totime;

// Save field
	var save_RMAIN_W_EX = '';
	var save_LASTCALLED = '';

var global_debug = 'N';
	var global_GET_POST = 'POST';

// Add allowed Y/N
	var GLOBAL_ADD_ALLOWED = 'N';

// Show group buttons
	var GLOBAL_SHOW_GROUP_BUTTONS = 'Y';

// Delete allowed Y/N
	var GLOBAL_DELETE_ALLOWED = 'N';

// sortMode
	var GLOBAL_SORTMODE = 'DESC';

var jsonDataSave = {};

var DFT_DATE_DISPLAY_FORMAT 	=  '<?php //echo $DFT_DATE_DISPLAY_FORMAT ?>';
	var DFT_LANGUAGE 				=  '<?php //echo $DFT_LANGUAGE ?>';

var GLOBAL_TOTALPAGESSTOPVALUE	=  10;

// Save field
	//var save_CFGNAM = '';

$(function () {
	  $.scrollUp({
		scrollName: 'scrollUp', // Element ID
		//topDistance: '1800', // Distance from top before showing element (px)
		//topSpeed: 300, // Speed back to top (ms)
		scrollDistance: '300', // Distance from top before showing element (px)
		scrollSpeed: 300, // Speed back to top (ms)
		animation: 'fade', // Fade, slide, none
		animationInSpeed: 200, // Animation in speed (ms)
		animationOutSpeed: 200, // Animation out speed (ms)
		scrollText: false, //'Scroll to top', // Text for element
		activeOverlay: false, // Set CSS color to display scrollUp active point, e.g '#00FFFF'
	  });
	});

//=============================================================================
// Get data
//=============================================================================
function getData( inputGetData )
{

// Reset, show all
	if ( inputGetData == '*RESET' ) {
		inputGetData = '';
		$('#input-fromdate').val('');
		$('#input-fromtime').val('');
		$('#input-todate').val('');
		$('#input-totime').val('');

// Update input variables
		input_fromdate = $('#input-fromdate').val();
		input_fromtime = $('#input-fromtime').val();
		input_todate = $('#input-todate').val();
		input_totime = $('#input-totime').val();

//Clear search
		thisGlobalTableData.search( '' );

}

//Only initialize datatables once, else just draw it
	if ( $.fn.dataTable.isDataTable( '#REEFTvisual_data' ) ) {
		console.log('1');
		thisGlobalTableData.draw(); // fire in the hole
	}
	else {
		console.log('2');
		setDataTables();
	}

}

//=============================================================================
// Set datatables
//=============================================================================
function setDataTables()
{

// Delete allowed?
	if ( GLOBAL_DELETE_ALLOWED == 'Y' ) {
		var show_the_delete_button = true;
	} else {
		var show_the_delete_button = false;
	}

// Get the current date line
	input_hub_webnam 	= $('#input-webnam').val();
	input_fromdate 		= $('#input-fromdate').val();
	input_fromtime 		= $('#input-fromtime').val();
	input_todate 		= $('#input-todate').val();
	input_totime 		= $('#input-totime').val();

parmData = '';

// Get the current date line
	input_L_STATUSC = $('#input-L_STATUSC').val();

new $('#REEFTvisual_data').DataTable({
		"ajax": {
			"url": 'HUB_TKTSTS_maintain_get.php',
			"type": global_GET_POST,
			"data": function (parmData) {

// Add custom parameters to the ajax call
				parmData.L_STATUSC	 = input_L_STATUSC;

// From date
				parmData.fromdate = input_fromdate.trim();
				parmData.fromtime = input_fromtime;

// To date
				parmData.todate = input_todate.trim();
				parmData.totime = input_totime;

},
			dataSrc: function (jsonData) {  //return data

var rpyCMPNO					= jsonData.header.rpyCMPNO;
				var rpyCMPNO_Name				= jsonData.header.rpyCMPNO_Name;
				var rpyFile_name				= jsonData.header.rpyFile_name
				var rpyFile_description			= jsonData.header.rpyFile_description
				var rpyTableRecordsFound		= jsonData.header.rpyTableRecordsFound
				var recordsTotal				= jsonData.header.recordsTotal

var returnCode 					= jsonData.header.returnCode;
				var returnMsg 					= jsonData.header.returnMsg;
				var entries_found 				= jsonData.header.entries_found;
				var response_sec 				= jsonData.header.response_sec;

var TAKT_BUFFER_NEXT_date		= jsonData.header.TAKT_BUFFER_NEXT_date;
				var TAKT_BUFFER_NEXT_time		= jsonData.header.TAKT_BUFFER_NEXT_time;
				var TAKT_BUFFER_NEXT_type		= jsonData.header.TAKT_BUFFER_NEXT_type;
				var TAKT_BUFFER_NEXT_feq		= jsonData.header.TAKT_BUFFER_NEXT_feq;

// Show load time
				$('#text-total-records-found').html( rpyTableRecordsFound );
				$('#text-total-records-found').html( recordsTotal );
				$('#load-time-from-database').html('entries found: ' + entries_found + ' (' + response_sec + ')');

$('#TAKT-BUFFER-NEXT').html(TAKT_BUFFER_NEXT_date + ' / ' + TAKT_BUFFER_NEXT_time);

// Set Company and file information
				if ( rpyFile_name != '' ) {
					$('#data-hub-company-information').html( '<span title="' + rpyFile_name + ' - ' + rpyFile_description + '">' + rpyCMPNO_Name + ' (' + rpyCMPNO + ')' + '</span>' ).css('font-size','1.3em');
				}

// Init button line fields
				var HTMLlineButtons 		= '';
				var HTMLlineButtonsModal 	= '';
				var selectedButtonClass 	= 'btn-dark';

//=====================================================================================
				// Create group buttons, only if wanted
				//=====================================================================================
				if ( GLOBAL_SHOW_GROUP_BUTTONS == 'Y' ) {

$.each( jsonData.header_buttons, function( index, object ){
						var buttonLine   = object.buttonLine;
						var buttonCount	 = object.buttonCount;

// if ( input_HUB_WEBNAM == buttonLine ) {
							// selectedButtonClass = 'btn-success';
						// } else {
							// selectedButtonClass = 'btn-dark';
						// }
							selectedButtonClass = 'btn-dark';

var selectButtonLineID 		= 'select-button-line-id-' + buttonLine;
						var selectButtonLineIDmodal = 'select-button-line-id-modal-' + buttonLine + '_' + buttonCount;

HTMLlineButtons 		+=	'<button type="button" onclick="setWebserviceSearch(\'' + buttonLine + '\')" style="cursor:default" id="' + selectButtonLineID + '" class="btn ' + selectedButtonClass + ' select-button-line btn-sm mr-1 mb-1">'
												+ 	buttonLine + ' (<b>' + buttonCount + '</b>)'
												+	'</button>'

HTMLlineButtonsModal 	+=	'<button type="button" onclick="selectGroupValueModal(\'' + buttonLine + '\')" style="width:100px" id="' + selectButtonLineIDmodal + '" class="select-button-line-modal btn btn-primary btn-sm mr-1 mb-1">'
												+ 	buttonLine
												+	'</button>'

});

// Reset
					HTMLlineButtons 		+=	'<button type="button" onclick="setWebserviceSearch(\'' + '' + '\')" style="cursor:default" id="' + 'RESET' + '" class="btn ' + 'btn-warning' + ' select-button-line btn-sm mr-1 mb-1">'
											+ 	'<b>' + 'RESET' + '</b>'
											+	'</button>'

$('#data-result-button-group').html(HTMLlineButtons);
					$('#data-result-button-group-modal').html(HTMLlineButtonsModal);

}
				//=====================================================================================

return jsonData.data;
			}
		},
		searching: true,
		processing: true,
		serverSide: true,
        responsive: false,
		fixedHeader: true,
        order: [[ 18, "asc" ],[ 19, "asc" ]],

// Control the order on the screen
		colReorder:
		{
			order: [18, 0 , 1 , 2 , 3 , 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 17, 15, 16, 19, 20, 21, 22]
		},

columnDefs: [
			// Make sure the sorts toggle asc/desc and not asc/desc/no-sort
			{
				orderSequence: ['asc', 'desc'], targets: ['_all']
			},

// // Make sure that buttons are not "hided" when responsive kicks in
			{ responsivePriority: 4, targets: 1 },
			// { responsivePriority: 2, targets: 0 },
			// { responsivePriority: 3, targets: 1 },
			// { responsivePriority: 4, targets: 2 },
			// { responsivePriority: 5, targets: 3 },
			// { responsivePriority: 6, targets: 4 },
			// { responsivePriority: 20, targets: 7 },
			// { responsivePriority: 30, targets: 6 },
			// { responsivePriority: 40, targets: 5 },
			// { responsivePriority: 50, targets: 4 },
			// { responsivePriority: 60, targets: 3 },

{
				 "targets": [ 22 ],
				 "visible": show_the_delete_button,
				 "searchable": false,
				 "orderable": false
			 },
			 {
				 "targets": [ 13,14,15,16,17,19 ],
				 "visible": true,
				 "searchable": false,
				 "orderable": false
			 },
			 {
				"targets": [ 2,3 ],
				"max-width": '120px',
				"className": "text-truncate-dt"  //class to mimic text-truncate in dt
			 },
			 {
				"targets": [ 5,6,7,8,9,10,11,12 ],
				"visible": false,
				"searchable": false,
				"orderable": false
			 },
			 {
				"targets": [ 3,15,16,17,18 ],
				"className": "text-align-center-dt"
			}

],
		columns:
				[

{ data: "REFERENCE" }, 	// 0
					{
						// 1
						// Since we are combining multiple data fields, use null as the data source
						data: 'LASTCALLED',
						render: function (data, type, row, meta)
						{
							// Set time text
							var myTimeStamp = '<span ondblclick="copyToClipBoard(\'' + row.LASTCALLED + '\')"  title="Double click to copy to clipboard - TOK_TIMSTP: ' + row.LASTCALLED + '">' + row.LASTCALLED_DATE + ' ' + row.LASTCALLED_TIME + '</span>';

return myTimeStamp;
						}
					},
					{
						// 2
						// Since we are combining multiple data fields, use null as the data source
						data: 'TAKTTIME',
						render: function (data, type, row, meta)
						{
							// Set time text
							var myTimeStamp = row.TAKTTIME_HMS

return myTimeStamp;
						}
					},
					{ data: "L_STATUSC" }, 		// 3
					{
						// 3
						// Since we are combining multiple data fields, use null as the data source
						data: 'L_STATUST',
						render: function (data, type, row, meta)
						{
							
							var L_STATUSC_color = 'text-info';
							
							// Set time text
							if ( row.L_STATUSC == '1003' ) {
								L_STATUSC_color = 'text-success';
							}
							if ( row.L_STATUSC == '1030' ) {
								L_STATUSC_color = 'text-warning';
							}
							if ( row.L_STATUSC == '1004' || row.L_STATUSC == '1012' ) {
								L_STATUSC_color = 'text-danger';
							}
							if ( row.L_STATUSC == '1002' ) {
								L_STATUSC_color = 'text-info';
							}

// Set color to text
							myText = '<div class="font-weight-bold ' + L_STATUSC_color + '">' + row.L_STATUST + '</div>'

return myText;
						}
					},
					{ data: "RMAIN_W_EX" }, 	// 5
					{ data: "RMAIN_M_EX" }, 	// 6
                    { data: "NXTTKWEXT1" }, 	// 7
                    { data: "NXTTKMEXT1" }, 	// 8
                    { data: "NXTTKWEXT2" }, 	// 9
                    { data: "NXTTKMEXT2" }, 	// 10
                    { data: "TOTLIRUNSC" }, 	// 11
                    { data: "TOTLISTPSC" }, 	// 12
                    { data: "TOTLIRUNTX" }, 	// 13
                    { data: "TOTLISTPTX" }, 	// 14
                    { data: "PRDCNT" }, 		// 15
                    { data: "PRDCNT_ER" }, 		// 16
                    { data: "PRDCNT_EXP" }, 	// 17
                    { data: "SEQUENCE" }, 		// 18
                    { data: "SHORTNAME" }, 		// 19
                    { data: "LONGNAME" }, 		// 20
					{
						// 21
						// Since we are combining multiple data fields, use null as the data source
						data: null,
						render: function (data, type, row, meta)
						{
							// Create edit button
							var myButton = '<button id="edt-' + row.LASTCALLED + '_' + row.REFERENCE + '" class="edit-btn btn btn-primary btn-block text-truncate xmr-1"><?php echo $datahub_button_show_details ?></button>';
							return myButton;
						}
					},
					{
						// 22
						// Since we are combining multiple data fields, use null as the data source
						data: null,
						render: function (data, type, row, meta)
						{
							// Create delete button
							var myButton = '<button id="dlt-' + '-' + row.LASTCALLED + '_' + row.REFERENCE + '" class="delete-btn btn btn-danger text-truncate btn-block xmr-1"><?php echo $datahub_button_delete ?></button>';
							return myButton;
						}
					}
                ],
		pageLength: 25,
		lengthChange: true,
		layout: {
			top1Start: {
				pageLength: {
						menu: [10, 25, 50, 100 ]
				}
			},
			top1End: [{
				search: {
					placeholder: '<?php echo $datahub_datatable_Search_text ?>',
					processing: true
				}

}],
			topStart: {
				info:{
					 }
			},
			topEnd: {
				paging: {
					buttons: 8,
					firstLast: true,
					boundaryNumbers: true,
				}
			},
			bottomStart: {
				buttons: [
					{
						extend: 'copyHtml5',
						text: '<img src="images/copy.png" height="25"> Copy to Clipboard',
						titleAttr: 'Copy',
						title: 'DATAHUB - Webservice Data Export - Copy to clipboard',
						exportOptions: {
							// Fields to export (https://datatables.net/reference/button/csv#Examples)
							columns: [0,1,2,3,4,5]
						}

},
					{
						extend: 'excelHtml5',
						text: '<img src="images/microsoft_excel_logo.png" height="25"> Excel',
						titleAttr: 'Excel',
							title: function(){
								return 'DATAHUB - Webservice Data Export';
							},
							filename: function(){
								var p_id = moment().format('YYYY-MM-DD HH.mm.ss');
								return 'DATAHUB - Webservice Data Export - ' + p_id;
							},
							exportOptions: {
								// Fields to export (https://datatables.net/reference/button/csv#Examples)
								columns: [0,1,2,3,4,5]
							}
					},
					{
						extend: 'pdfHtml5',
						text: '<img src="images/pdf_logo.png" height="25"> PDF',
						titleAttr: 'PDF',
						orientation: 'landscape',
						title: 'DATAHUB - Webservice Data Export - PDF',
						filename: function(){
								var p_id = moment().format('YYYY-MM-DD HH.mm.ss');
								return 'DATAHUB - Webservice Data Export - PDF - ' + p_id;
						},
						exportOptions: {
							// Fields to export (https://datatables.net/reference/button/csv#Examples)
						columns: [0,1,2,3,4,5],
						modifier: {
							page: 'all'
							}
						}
					}
				]
			},
			bottomEnd: {
				paging: {
					buttons: 12,
					firstLast: true,
					boundaryNumbers: true
				}
			}
		},
		language:
		{
					"decimal":        ",",
					"thousands":      ".",
					"emptyTable":     "<?php echo $datahub_datatable_emptyTable ?>",
					"info":           "<?php echo $datahub_datatable_Info ?>",
					"infoEmpty":      "<?php echo $datahub_datatable_InfoEmpty ?>",
					"InfoFiltered":   "<?php echo $datahub_datatable_InfoFiltered ?>",
					"infoPostFix":    "",
					"lengthMenu":     "<?php echo $datahub_datatable_LengthMenu ?>",
					"loadingRecords": "",
					"processing":     "<?php echo $datahub_datatable_Processing ?>",
					"search":         "<?php echo $datahub_datatable_Search ?>",
					"zeroRecords":    "<?php echo $datahub_datatable_ZeroRecords ?>",
					"paginate":
						{
							"first":    "<?php echo $datahub_datatable_First ?>",
							"last":     "<?php echo $datahub_datatable_Last ?>",
							"next":     "<?php echo $datahub_datatable_Next ?>",
							"previous": "<?php echo $datahub_datatable_Previous ?>"
						},
					"aria": {
						"orderable":  "Order by this column",
						"orderableReverse": "Reverse order this column"
					}

},
        "rowCallback": function(row, data, index)
		{

},
        "preDrawCallback": function(settings)
		{
		},
		"initComplete": function ()
		{

}

});

//=============================================================================
	// Setup the data to be able to update the table without reloading from the server
	//=============================================================================

// Save the table in a global variable
		thisGlobalTableData = $('#REEFTvisual_data').DataTable();

// Handle click on "Edit" button
		$('#REEFTvisual_data tbody').on('click', '.edit-btn', function() {
			thisCurrentRow 	= $(this).closest('tr');
			thisGlobalRowData = thisGlobalTableData.row(thisCurrentRow).data();

// Debug
			// console.log("edit");
			// console.log(thisGlobalRowData);
			//console.log(thisCurrentRow);

dataChange();

});

// Handle click on "Delete" button
		$('#REEFTvisual_data tbody').on('click', '.delete-btn', function() {
			thisCurrentRow 	= $(this).closest('tr');
			thisGlobalRowData = thisGlobalTableData.row(thisCurrentRow).data();

// Debug
			// console.log(thisGlobalRowData);
			// console.log(thisCurrentRow);

dataDeleteConfirm();

});

//=============================================================================

//=============================================================================
	// Place curor in search field - the wrapper id is provided by datatables - debug it!
	//=============================================================================
	$('#REEFTvisual_data_wrapper div.dt-search .dt-input').focus();
	//=============================================================================

}

//=============================================================================
// Reason addd  -- not used
//=============================================================================
function dataAdd ( input_pk_type )
{

var myLASTCALLED = $('#input-LASTCALLED').val();

resetModalInputFields();
			setModalInputDefaultFields();

$('#input-mode').val('*add');

// Reset save field
			save_LASTCALLED = '';
			save_REFERENCE = '';

// Reset modal message
			resetModalMessage();

// Remove key fields readonly
			$('#modal-input-LASTCALLED').removeAttr('readonly','readonly');
			$('#data-result-button-group-modal').removeClass('d-none');

// Show modal
			$('#HUB_TKTSTS_maintainModal').modal('show');

$('#HUB_TKTSTS_maintainModal').on('shown.bs.modal', function () {
				$('#modal-input-LASTCALLED').trigger('focus');
			})

}

//=============================================================================
// Show details
//=============================================================================
function dataChange( )
{

var row = thisGlobalRowData;

// Save in fields
	var REFERENCE      	= row["REFERENCE"];
	var LASTCALLED    	= row["LASTCALLED"];
	var LASTCALLED_DATE	= row["LASTCALLED_DATE"];
	var LASTCALLED_TIME	= row["LASTCALLED_TIME"];
	var TAKTTIME      	= row["TAKTTIME"];
	var TAKTTIME_HMS   	= row["TAKTTIME_HMS"];
	var L_STATUSC      	= row["L_STATUSC"];
	var L_STATUST       = row["L_STATUST"];
	var RMAIN_W_EX      = row["RMAIN_W_EX"];
	var RMAIN_M_EX      = row["RMAIN_M_EX"];
	var NXTTKWEXT1      = row["NXTTKWEXT1"];
	var NXTTKMEXT1      = row["NXTTKMEXT1"];

var NXTTKWEXT2      = row["NXTTKWEXT2"];
	var NXTTKMEXT2      = row["NXTTKMEXT2"];
	var TOTLIRUNSC      = row["TOTLIRUNSC"];
	var TOTLISTPSC      = row["TOTLISTPSC"];
	var TOTLIRUNTX      = row["TOTLIRUNTX"];
	var TOTLISTPTX      = row["TOTLISTPTX"];
	var PRDCNT      	= row["PRDCNT"];
	var PRDCNT_ER      	= row["PRDCNT_ER"];
	var PRDCNT_EXP      = row["PRDCNT_EXP"];
	var SEQUENCE	    = row["SEQUENCE"];

var counter     = row["counter"];

$('#input-mode').val('*update');

save_LASTCALLED = LASTCALLED;
	save_REFERENCE = REFERENCE;

// Move to input fields
	$('#modal-input-counter').val(counter);

$('#modal-input-REFERENCE').val(REFERENCE);

$('#modal-input-LASTCALLED').val(LASTCALLED);
	$('#modal-input-LASTCALLED_DATE_TIME').val(LASTCALLED_DATE + ' ' + LASTCALLED_TIME);

$('#modal-input-TAKTTIME').val(TAKTTIME);
	$('#modal-input-TAKTTIME_HMS').val(TAKTTIME_HMS);

$('#modal-input-TAKTTIME').val(TAKTTIME);
	$('#modal-input-L_STATUSC').val(L_STATUSC);
	$('#modal-input-L_STATUST').val(L_STATUST);
	$('#modal-input-RMAIN_W_EX').val(RMAIN_W_EX);
	$('#modal-input-RMAIN_M_EX').val(RMAIN_M_EX);
	$('#modal-input-NXTTKWEXT1').val(NXTTKWEXT1);
	$('#modal-input-NXTTKMEXT1').val(NXTTKMEXT1);
	$('#modal-input-NXTTKWEXT2').val(NXTTKWEXT2);
	$('#modal-input-NXTTKMEXT2').val(NXTTKMEXT2);
	$('#modal-input-TOTLIRUNSC').val(TOTLIRUNSC);
	$('#modal-input-TOTLISTPSC').val(TOTLISTPSC);
	$('#modal-input-TOTLIRUNTX').val(TOTLIRUNTX);
	$('#modal-input-TOTLISTPTX').val(TOTLISTPTX);
	$('#modal-input-PRDCNT').val(PRDCNT);
	$('#modal-input-PRDCNT_ER').val(PRDCNT_ER);
	$('#modal-input-PRDCNT_EXP').val(PRDCNT_EXP);
	$('#modal-input-SEQUENCE').val(SEQUENCE);

// Make key fields readonly
	$('#modal-input-LASTCALLED').attr('readonly','readonly');
	$('#data-result-button-group-modal').removeClass('d-none');

$('.read-only-class').attr('readonly','readonly');

// Reset modal message
	resetModalMessage();

// Show modal
	$('#HUB_TKTSTS_maintainModal').modal('show');

$('#HUB_TKTSTS_maintainModal').on('shown.bs.modal', function () {
		$('#modal-input-SEQUENCE').trigger('focus');
	})

}

//=============================================================================
// Save
//=============================================================================
function dataSave()
{
	// Reset modal message
	resetModalMessage();

// Check content of fields
	if ( $('#modal-input-LASTCALLED').val() == '' ) {
		$('#modal-message').addClass('border-bottom').html( '<?php echo $datahub_error0082 ?>' );
		$('#modal-save-button').addClass('disabled').prop("disabled", true);
		$('#modal-input-LASTCALLED').trigger('focus');
		return false;
	}

// if ( $('#modal-input-TOK_ALPHA').val() == '' ) {
		// $('#modal-message').addClass('border-bottom').html( '<?php echo $datahub_error0085 ?>' );
		// $('#modal-save-button').addClass('disabled').prop("disabled", true);
		// $('#modal-input-TOK_ALPHA').trigger('focus');
		// return false;
	// }

if ( $('#modal-input-TOK_ADRNBR').val() == '' ) {
		$('#modal-message').addClass('border-bottom').html( '<?php echo $datahub_error0084 ?>' );
		$('#modal-save-button').addClass('disabled').prop("disabled", true);
		$('#modal-input-TOK_ADRNBR').trigger('focus');
		return false;
	}

if ( $('#modal-input-LASTCALLED').val() == '' ) {
		$('#modal-message').addClass('border-bottom').html( '<?php echo $datahub_error0086 ?>' );
		$('#modal-save-button').addClass('disabled').prop("disabled", true);
		$('#modal-input-LASTCALLED').trigger('focus');
		return false;
	}

// if ( $('#modal-input-REFERENCE').val() == '' ) {
		// $('#modal-message').addClass('border-bottom').html( '<?php echo $datahub_error0083 ?>' );
		// $('#modal-save-button').addClass('disabled').prop("disabled", true);
		// $('#modal-input-REFERENCE').trigger('focus');
		// return false;
	// }

var mode = $('#input-mode').val();

//===============================================================================
	// Remove # if any
	//===============================================================================

// Setup remove string
		let mySaveString;

// var myWorkField = $('#modal-input-DESCP1').val();
		// myWorkField = myWorkField.replace("#", "");
		// $('#modal-input-DESCP1').val( myWorkField );

// var myWorkField = $('#modal-input-DESCP2').val();
		// myWorkField = myWorkField.replace("#", "");
		// $('#modal-input-DESCP2').val( myWorkField );

var myWorkField = $('#modal-input-TOK_ENV').val();
		myWorkField = myWorkField.replace(",", ".");
		myWorkField = parseFloat(myWorkField).toFixed(3).toString();
		$('#modal-input-CHRMIN').val( myWorkField );

var myWorkField = $('#modal-input-TOK_ENVCOL').val();
		myWorkField = myWorkField.replace(",", ".");
		myWorkField = parseFloat(myWorkField).toFixed(3).toString();
		$('#modal-input-CHRMAX').val( myWorkField );

var myWorkField = $('#modal-input-TOK_JASSVR').val();
		myWorkField = myWorkField.replace(",", ".");
		myWorkField = parseFloat(myWorkField).toFixed(0).toString();
		$('#modal-input-DBGVAL').val( myWorkField );

//===============================================================================

// Make sure key does not have space and are in uppercase
	// var myWorkField = $('#modal-input-HUB_WEBNAM').val();
	// myWorkField = myWorkField.replace(" ", "_");
	// myWorkField = myWorkField.toUpperCase();
	// $('#modal-input-HUB_WEBNAM').val( myWorkField );

// Make array and json
	var myData = $('#dataForm').find('input, select, textarea').serializeArray();

var result = JSON.stringify(myData);

var result = encodeURIComponent( result );
	// console.log(result);
	// console.log(myData);
	// return;

var parmData = 'data=' + result
				 + '&mode=' + mode
				 ;

$.ajax({
		url: "HUB_TKTSTS_maintain_save.php",
		type: "POST",
		data: parmData,
		dataType: "json",
		cache: false,
	})
	.done(function( jsonData ) {

//=================================================================
		// START - Update the table without doing a server reload
		// Only update
		//=================================================================
		if ( mode == '*update' ) {

event.preventDefault();

// Debug
			// console.log(myGlobalRowData[0]);
			// console.log(myGlobalRowData[1]);
			// console.log(myGlobalRowData[2]);
			// console.log(myCurrentRow);
			// console.table(myGlobalTableData);

// Get the data for the "Change/Delete button", so we do not need to create it again
			// myChangeButtonData = myGlobalRowData[6];
			// myDeleteButtonData = myGlobalRowData[7];

//==============================================
			// Use this if you want to update the whole row
			//==============================================
			// myGlobalTableData.row(myCurrentRow).data([
														// modal_input_HUB_WEBNAM,
														// modal_input_LSTCAL,
														// modal_input_DESCP1,
														// modal_input_DESCP2,
														// modal_input_COUNT,
														// modal_input_SERTYP,
														// myChangeButtonData,
														// myDeleteButtonData,
														// modal_input_DESCP1,
														// modal_input_DESCP2
													// ])
													// .draw(false)
													// ;

//=======================================================
			// Use this if you want to update one or more table cells
			//=======================================================

// thisGlobalTableData.cell(thisCurrentRow,  0  ).data( $('#modal-input-LASTCALLED').val() );
			// thisGlobalTableData.cell(thisCurrentRow,  1  ).data( $('#modal-input-RMAIN_W_EX').val() );
			// thisGlobalTableData.cell(thisCurrentRow,  2  ).data( $('#modal-input-TOK_ADRNBR').val() + '<br>' + $('#modal-input-TOK_ALPHA').val() );
			// thisGlobalTableData.cell(thisCurrentRow,  3  ).data( $('#modal-input-REFERENCE').val()  );
			// thisGlobalTableData.cell(thisCurrentRow,  4  ).data( $('#modal-input-LASTCALLED').val() );
			// thisGlobalTableData.cell(thisCurrentRow,  6  ).data( $('#modal-input-TOK_ROLE').val() );
			// thisGlobalTableData.cell(thisCurrentRow,  7  ).data( $('#modal-input-TOK_ENV').val() );
			// thisGlobalTableData.cell(thisCurrentRow,  8  ).data( $('#modal-input-TOK_ENVCOL').val() );
			// 9 = Show on chart Y/N
			// 10 = Edit button
			// 11 = Delete button
			// 12 = Transactions
			// 13 = Chart
			// thisGlobalTableData.cell(thisCurrentRow,  14 ).data( $('#modal-input-TOK_JASSVR').val() );
			// thisGlobalTableData.cell(thisCurrentRow,  15 ).data( $('#modal-input-TOK_ADRNBR').val() );
			// thisGlobalTableData.cell(thisCurrentRow,  16 ).data( $('#modal-input-TOK_ALPHA').val() );
			// thisGlobalTableData.cell(thisCurrentRow,  17 ).data( $('#modal-input-TOK_APPRLS').val() );
			// thisGlobalTableData.cell(thisCurrentRow,  18 ).data( $('#modal-input-TOK_MACHIN').val() );

// Show new color
			// var TOK_APPRLS_TEXT = '<div style="display:block;margin:auto;width:25px;height:25px; background-color:' + $('#modal-input-TOK_APPRLS').val() + '">&nbsp;</div>';
			// thisGlobalTableData.cell(thisCurrentRow,  5  ).data( TOK_APPRLS_TEXT );
			// //thisGlobalTableData.cell(thisCurrentRow,  5  ).data( TOK_APPRLS_TEXT ).draw(false);

// if ( $('#modal-input-TOK_MACHIN').val() == 'N' ) {
				// TOK_MACHIN_text = '<?php echo $datahub_NO ?>';
			// } else {
				// TOK_MACHIN_text = '<?php echo $datahub_YES ?>';
			// }
			// thisGlobalTableData.cell(thisCurrentRow,  9  ).data( TOK_MACHIN_text );

}
		//=================================================================
		// END - Update the table without doing a server reload
		//=================================================================

//=================================================================
		// Close the modal
		//=================================================================
		$('#HUB_TKTSTS_maintainModal').modal('hide');

//=================================================================
		// Only when add
		//=================================================================
		if ( mode == '*add' ) {
			var myButtonID = 'select-button-line-id-' + $('#input-LASTCALLED').val();
			$('#' + myButtonID).click();
			getData('');
		}

})
	.always(function( jsonData ) {

// Reset mode
		$('#input-mode').val('');

// Reset input fields
		resetModalInputFields();

})
	.fail(function( xhr, ajaxOptions, thrownError ) {
		console.log('I am failed..');
		console.log( thrownError );
		console.log( xhr );

});

}

//=============================================================================
// Delete confirm
	//=============================================================================
function dataDeleteConfirm( )
{

$('#input-mode').val('*delete');

var row = thisGlobalRowData;

var input_LASTCALLED = row["LASTCALLED"];

$('#confirm-delete-LASTCALLED').val(input_LASTCALLED);

// Create confirm text
	$('#confirm-delete-text-LASTCALLED').html(input_LASTCALLED);

$('#HUB_TKTSTS_confirmDeleteModal').modal('show');

}

//=============================================================================
// Delete
//=============================================================================
function dataDeleteExec()
{
	// Reset modal message
	resetModalMessage();

var mode = $('#input-mode').val();

// Make array and json
	var myData = $('#dataForm-delete').find('input, select').serializeArray();
	var result = JSON.stringify(myData);

// console.log(result);
	// console.log(myData);
	//return;

var parmData = 'data=' + result
				 + '&mode=' + mode
				 ;

$.ajax({
		url: "HUB_TKTSTS_maintain_save.php",
		type: "POST",
		data: parmData,
		dataType: "json",
		cache: false,
	})
	.done(function( jsonData ) {

$('#HUB_TKTSTS_confirmDeleteModal').modal('hide');

//=================================================================
	// Only when add
	//=================================================================
	if ( mode == '*delete' ) {
		var myButtonID = 'select-button-line-id-' + $('#input-LASTCALLED').val();
		$('#' + myButtonID).click();

resetModalInputFields();

getData('');
	}

})
	.always(function( jsonData ) {

})
	.fail(function( xhr, ajaxOptions, thrownError ) {
		console.log('I am failed..');
		console.log( xhr );

});

}

//=============================================================================
// Check if userid exists
//=============================================================================
function checkDataExists()
{

return;

var LASTCALLED = $('#modal-input-LASTCALLED').val();

// If update, then the "orginal" code is ok
	if ( $('#input-mode').val() == '*update' ) {
		if ( LASTCALLED == save_LASTCALLED ) {
	//		return;
		}
	}

var parmData = 'LASTCALLED=' + RMAIN_W_EX
				 ;

$.ajax({
		url: "hub_conchk_get.php",
		type: "GET",
		data: parmData,
		dataType: "json",
		cache: false,
	})
	.done(function( jsonData ) {

var returnCode 				= jsonData.header.returnCode;
		var returnMsg 				= jsonData.header.returnMsg;
		var entries_found 			= jsonData.header.entries_found;

var returnConfigValue 		= jsonData.header.returnConfigValue;
		var returnConfigValueText	= jsonData.header.returnConfigValueText;

if ( returnConfigValue	== '50') {
			$('#modal-message').addClass(' border-bottom').html( '<?php echo $datahub_error0087 ?>' );
			$('#modal-save-button').addClass('disabled').prop("disabled", true);
			$('#modal-input-LASTCALLED').trigger('focus');
			return false;
		} else {
			// DESCP = jsonData.detail[0].DESCP
			// $('#modal-input-REFERENCE').val( DESCP );
		}

// Reset modal message
		resetModalMessage();

})
	.always(function( jsonData ) {

})
	.fail(function( xhr, ajaxOptions, thrownError ) {
		console.log('I am failed..');
		console.log( xhr );

});

}

//=============================================================================
// Show deleted
//=============================================================================
function showDeleted()
{

var show_deleted = $('#input-show-deleted').val();

if ( show_deleted == 'Y' ) {
		$('#button-show-deleted').html('<?php echo $datahub_NO ?>');
		$('#input-show-deleted').val('N');
	} else {
		$('#button-show-deleted').html('<?php echo $datahub_YES ?>');
		$('#input-show-deleted').val('Y');
	}

}

//=============================================================================
// Set default modal input fields
//=============================================================================
function setModalInputDefaultFields()
{

var myLASTCALLED = $('#input-LASTCALLED').val();

// $('#modal-input-RMAIN_W_EX').val('1');

// $('#modal-input-TOK_APPRLS').val( $('#input-current-date').val() );
			// $('#modal-input-TOK_ROLE').val( $('#input-current-time').val() );

}

//=============================================================================
// Reset modal input fields
//=============================================================================
function resetModalInputFields()
{

$('#modal-input-REFERENCE').val('');
			$('#modal-input-LASTCALLED').val('');
			$('#modal-input-TAKTTIME').val('');
			$('#modal-input-L_STATUSC').val('');
			$('#modal-input-L_STATUST').val('');
			$('#modal-input-RMAIN_W_EX').val('');
			$('#modal-input-RMAIN_M_EX').val('');
			$('#modal-input-NXTTKWEXT1').val('');
			$('#modal-input-NXTTKMEXT1').val('');
			$('#modal-input-NXTTKWEXT2').val('');
			$('#modal-input-NXTTKMEXT2').val('');
			$('#modal-input-TOTLIRUNSC').val('');
			$('#modal-input-TOTLISTPSC').val('');
			$('#modal-input-TOTLIRUNTX').val('');
			$('#modal-input-TOTLISTPTX').val('');
			$('#modal-input-PRDCNT').val('0');
			$('#modal-input-PRDCNT_ER').val('0');
			$('#modal-input-PRDCNT_EXP').val('0');
			$('#modal-input-SEQUENCE').val('0');

$('#input-mode').val('');

}

//=============================================================================
// Log off
//=============================================================================
function signoff()
{

window.location.href = "logout.php";

}

//=============================================================================
// Load page
//=============================================================================
function loadPage(url, p1, p2, p3)
{

window.location.href = url;

}

//=============================================================================
// Reset modal message
//=============================================================================
function resetModalMessage() {

// Reset
	//$('#modal-message').removeClass('p-2 font-weight-bold border border-danger rounded bg-light').html( '&nbsp;' );

$('#modal-message').removeClass('border-bottom').html( '&nbsp;' );
	$('#modal-save-button').removeClass('disabled').prop("disabled", false);

}

//=============================================================================
// Clean input string
//=============================================================================
function cleanInputString( myWorkField )
{

let charactersToRemove = '?#"\'';
	let myPattern = new RegExp('[' + charactersToRemove + ']', 'g');

myWorkField = myWorkField.replace(myPattern,'');

return myWorkField;

}

//=============================================================================
// Full screen popup
//=============================================================================
function popUpFull( url, p1, p2, p3 )
{

var winname = 'win_' + url;

params  = 'width='+screen.width;
	params += ', height='+screen.height;
	params += ', top=0, left=0'
	params += ', fullscreen=yes';
	params += ',scrollbars=1';

overview_win = window.open(url,winname, params);
	if (window.focus) {overview_win.trigger('focus')}
	return false;

}

//=============================================================================
// screen popup - center
//=============================================================================
function popUpCenter(url, p1, p2, p3)
{

var v1_w  = screen.availWidth;
	var v1_h  = screen.availHeight;

if ( parseInt(v1_w) > 1800 ) {
		v1_w = 1800;
		v1_h = v1_h - 200;
		v1_center = v1_w/0.8;
	}

// Center popup as good as possible
	var left = (screen.width - v1_w) / 2;
	var top = (screen.height - v1_h) / 4;

var winname = 'win_' + url;

params  = 'width='+v1_w;
	params += ', height='+v1_h;
	params += ', top=' + top + ', left=' + left;
	params += ', fullscreen=yes';
	params += ',scrollbars=1';

overview_win = window.open(url,winname, params);
	if (window.focus) {overview_win.trigger('focus')}
	return false;

}

//=============================================================================
// screen popup - center - bigger
//=============================================================================
function popUpCenterBig(url, p1, p2, p3)
{

var v1_w  = screen.availWidth;
	var v1_h  = screen.availHeight;

// Get 25%
	v1_w_pct = v1_w * 0.25;

v1_w_new = v1_w - v1_w_pct;

if ( v1_w_new < 1 ) {
		v1_w_new	= 1800;
	}

v1_w = v1_w_new;
	v1_h = v1_h - 200;
	v1_center = v1_w/0.8;

// Center popup as good as possible
	var left = (screen.width - v1_w) / 2;
	var top = (screen.height - v1_h) / 4;

var winname = 'win_' + url;

params  = 'width='+v1_w;
	params += ', height='+v1_h;
	params += ', top=' + top + ', left=' + left;
	params += ', fullscreen=yes';
	params += ',scrollbars=1';

overview_win2 = window.open(url, winname, params);
	if (overview_win2 && !overview_win2.closed) {
		overview_win2.focus();
	}

}

//=============================================================================
// Popup top
//=============================================================================
function popUpTop(url, p1, p2, p3)
{

var winname = 'win_' + url;

w = 650;
	h = 750;

params  = 'width='+w;
	params += ', height='+h;
	params += ', top=0, left=0'
	params += ', fullscreen=no';
	params += ',scrollbars=1';

overview_win = window.open(url,winname, params);
	if (window.focus) {overview_win.trigger('focus')}
	return false;
}

let charactersToRemove = '?#"\'';
	let myPattern = new RegExp('[' + charactersToRemove + ']', 'g');

myWorkField = myWorkField.replace(myPattern,'');

return myWorkField;

}

//=============================================================================
// Select line modal
//=============================================================================
function selectGroupValueModal( inputLine )
{

$('#modal-input-LASTCALLED').val( inputLine );

var selectButtonLineID = 'select-button-line-id-modal-' + inputLine;

$('.select-button-line-modal').removeClass('btn-success').addClass('btn-primary');
	$('#' + selectButtonLineID).removeClass('btn-primary').addClass('btn-success');

// Place cursor
	$('#modal-input-LASTCALLED').trigger('focus');
	resetModalMessage();

}

//=============================================================================
// Reset line modal
//=============================================================================
function resetLineModal()
{

resetModalMessage()

let inputLine = $('#modal-input-LASTCALLED').val();

if ( inputLine == '' ) {
		$('.select-button-line-modal').removeClass('btn-success').addClass('btn-primary');
	}

}

//=============================================================================
// Close modal
//=============================================================================
function closeModal() {

$('#HUB_TKTSTS_maintainModal').modal('hide');

}

//=============================================================================
// Show details - modal
//=============================================================================
function dataListIFSfilePrompt()
{

$('#input-modal-list-current-file-pRpyNextOffSet').val( '0');

$('#modal-ifs-list-data-result').html('');
	$('#modal-ifs-list-messasge').html( '' );
	HTMLline02 = '';

dataListIFSfileExec();

// Show modal

$('#import_done_listIFSfileModal').modal('show');

$('#import_done_listIFSfileModal').one('shown.bs.modal', function () {
			//scrollToSomething( 'target' );
		})

}

$('#modal-ifs-list-progress').html('<span style="color: crimson">Loading data, please wait</span>');

var FILE_NAME  = $('#modal-input-TOK_FILE_NAME').val();
	var PATH_NAME  = $('#modal-input-TOK_FILENM').val();

// Current offset
	var nextOffSet = $('#input-modal-list-current-file-pRpyNextOffSet').val();

// Set some header info
	$('#modal-list-current-file').html( '<span title="' + PATH_NAME + '">' + FILE_NAME + '</span>' );

var parmData = 'FILE_NAME=' + FILE_NAME
				 + '&what_to_call=' + '*FILEPATH'
				 + '&dir_name=' + FILE_NAME
				 + '&ifs_file_path=' + PATH_NAME
				 + '&nextOffSet=' + nextOffSet
				 ;

//alert(parmData);

$.ajax({
		url: "hub_import_done_file_maintain_get.php",
		type: "GET",
		data: parmData,
		dataType: "json",
		cache: false,
	})
	.done(function( jsonData ) {

var rpyTotalRecordsFound 	= jsonData.header.rpyTotalRecordsFound;
		var pRpyNextOffSet 			= jsonData.header.pRpyNextOffSet;
		var lastLineNumber 			= jsonData.header.lastLineNumber;
		var pFileName	 			= jsonData.header.pFileName;
		var rpyBaseURL	 			= jsonData.header.rpyBaseURL;
		var rpyURL		 			= jsonData.header.rpyURL;

$('#input-modal-list-current-file-pRpyNextOffSet').val( pRpyNextOffSet );
		$('#input-base-url').val( rpyBaseURL );

// Create download link
		if ( rpyURL != '' ) {
			$('#modal-list-download-current-file').html( '<a title="Download" download="jan.txt"  target="_blank" class="btn btn-dark" href="' + rpyURL + '">' + '<i class="fa-thin fa-download"></i>' + '&nbsp;&nbsp;' + pFileName + '</a>' );
		}

$.each( jsonData.data, function( index, object ){

var LINE_NUMBER	= object.LINE_NUMBER;
					var LINE   		= object.LINE;

// if ( LINE_NUMBER == 1 ) {
						// var b_start = '<b>';
						// var b_stop	= '</b>';
					// } else {
						// var b_start = '';
						// var b_stop	= '';
					// }

var b_start = '';
						var b_stop	= '';

// Create line
					HTMLline02 += 	'<span class="" style="color:#B4B4B4">'
							   + 	LINE_NUMBER
							   +	'</span>'
							   + 	'&nbsp;&nbsp;&nbsp;&nbsp;'
							   +	b_start
							   +    LINE
							   +	b_stop
							   +	'<br>'
							   ;

});

// Show yourself to the world, you little fvcker
		$('#modal-ifs-list-data-result').html(HTMLline02);

// Make key fields readonly
		$('#modal-input-FILE_NAME').attr('readonly','readonly');
		$('#data-result-button-group-modal').removeClass('d-none');

$('.read-only-class').attr('readonly','readonly');

// Reset modal message
		resetModalMessage();

if ( parseInt(lastLineNumber) > 0 ) {
			$('#modal-ifs-list-progress').html( 'Reocrds shown: ' + lastLineNumber );
			$('#modal-ifs-list-messasge').html( '' );
			$('#input-modal-last-line-number').val(lastLineNumber);

if ( parseInt(lastLineNumber) < parseInt(pRpyNextOffSet) ) {
				$('#modal-ifs-list-messasge').html( 'All data shown...' );
			}

} else {
			$('#modal-ifs-list-progress').html( 'Reocrds shown: ' + $('#input-modal-last-line-number').val() );
			$('#modal-ifs-list-messasge').html( 'All data shown...' );
		}

})
	.always(function( jsonData ) {

})
	.fail(function( xhr, ajaxOptions, thrownError ) {
		console.log('I am failed..');
		console.log( thrownError );
		console.log( xhr );

});

}

//=============================================================================
// Close modal - IFS listing
//=============================================================================
function closeModalIFSlist( action ) {

HTMLline02 = '';
	$('#modal-ifs-list-data-result').html('');
	$('#modal-ifs-list-messasge').html( '&nbsp;' );

if ( action == '*NORMAL') {
		$('#import_done_listIFSfileModal').modal('hide');
	}

// Close both modals
	if ( action == '*SUPER') {
		$('#import_done_listIFSfileModal').modal('hide');
		$('#buttton-close-modal').click();
	}

}

//=============================================================================
// Scroll to something
//=============================================================================
function scrollToSomething( target )
{

//$.scrollTo('0',3200);

thisID = '#' + target;
	$.scrollTo( thisID, 1000);

}

//=============================================================================
// Check if scroll reaches bottom  - controls lazy scroll
//=============================================================================
function chk_scroll(e)
{
    var elem = $(e.currentTarget);
    if (elem[0].scrollHeight - elem.scrollTop() == elem.outerHeight())
    {
		// Load more data
        console.log("bottom");
		dataListIFSfileExec();
    }

}

//=============================================================================
// Save file
//=============================================================================
function saveFile( i_filename )
{

var data = {
    key: 'value'
};
var fileName = i_filename;

// Create a blob of the data
var fileToSave = new Blob([JSON.stringify(data)], {
    type: 'application/json'
});

// Save the file
saveAs(fileToSave, fileName);

// var file = new File(["Hello, world!"], filename, {type: "application/json;charset=utf-8"});
	// saveAs(file);

}

//=============================================================================
// copy to clipboard
//=============================================================================
function copyToClipBoard( input_text_to_copy )
{

$('#myInput').val( input_text_to_copy );

// Get the text field
	var copyText = document.getElementById("myInput");

// Select the text field
	copyText.select();
	copyText.setSelectionRange(0, 99999); // For mobile devices

// Copy the text inside the text field
	navigator.clipboard.writeText(copyText.value);

// Alert the copied text
	alert( copyText.value + ' ' + 'copied to clipboard' );

}

//=============================================================================
// Set months
//=============================================================================
function setDefaultMonths() {

$('#default-month-buttons').html('');

var monthButtons = '';

var numberOfMonths = 6;

curMdrVar = numberOfMonths;

for (let step = 0; step < numberOfMonths; step++)
		{

curMdrVar = parseInt( curMdrVar ) - 1;
			//curMdrVar = step;

var defaultMonth = moment().subtract(curMdrVar, 'month').format("MM");

var monthName = setDefaultMonthName( defaultMonth );
			createDefaultMonthButton(curMdrVar, defaultMonth, monthName);
		}

}

//=============================================================================
// Create button
//=============================================================================
function createDefaultMonthButton( number, month, monthName )
{

var thisId = 'default-button-' + month;

var currentYear = getDefaultYearCalc( number, month, monthName );

var monthButton = '<button type="button" class="btn-default-date-interval btn btn-dark mr-1 mb-1" id="' + thisId + '" onclick="setDefaultFromToDateCalc(\'' + number + '\',\'' + month + '\')">' + monthName + ' ' + currentYear + '</button>'

$('#default-month-buttons').append(monthButton);

}

//=============================================================================
// Set month names
//=============================================================================
function setDefaultMonthName( month ) {

var monthName = '';

if ( month == '01') {
		monthName = '<?php echo $datahub_month_01 ?>';
	}
	else if ( month == '02') {
		monthName = '<?php echo $datahub_month_02 ?>';
	}
	else if ( month == '03') {
		monthName = '<?php echo $datahub_month_03 ?>';
	}
	else if ( month == '04') {
		monthName = '<?php echo $datahub_month_04 ?>';
	}
	else if ( month == '05') {
		monthName = '<?php echo $datahub_month_05 ?>';
	}
	else if ( month == '06') {
		monthName = '<?php echo $datahub_month_06 ?>';
	}
	else if ( month == '07') {
		monthName = '<?php echo $datahub_month_07 ?>';
	}
	else if ( month == '08') {
		monthName = '<?php echo $datahub_month_08 ?>';
	}
	else if ( month == '09') {
		monthName = '<?php echo $datahub_month_09 ?>';
	}
	else if ( month == '10') {
		monthName = '<?php echo $datahub_month_10 ?>';
	}
	else if ( month == '11') {
		monthName = '<?php echo $datahub_month_11 ?>';
	}
	else if ( month == '12') {
		monthName = '<?php echo $datahub_month_12 ?>';
	}
	else {
		monthName = 'Unknown: ' + month;
	}

return monthName;

}

//=============================================================================
// Set default from 7 to date
//=============================================================================
function getDefaultYearCalc( sub_month, month )
{

// Calcualte date intervals
		var defaultFromDate	= moment().subtract( parseInt(sub_month), 'month').format("YYYY-MM-01" );
		var defaultToDate	= moment().add(1, 'day').format("YYYY-MM-DD");
		var defaultToDate   = moment().subtract( parseInt(sub_month), 'month').endOf('month').format('YYYY-MM-DD');

var currentYear   = moment(defaultFromDate).format('YYYY');
		//console.log(defaultFromDate + ' ' + defaultToDate + ' ' + currentYear);

return currentYear;

}

// Move to input fields
		$('#input-fromdate').val( defaultFromDate );
		$('#input-todate').val( defaultToDate );

$('#input-fromtime').val( '00:00' );
		$('#input-totime').val( '23:59' );

var thisId = 'default-button-' +  month;

$('.btn-default-date-interval').removeClass('btn-success').addClass('btn-dark');
		$('#' + thisId).removeClass('btn-dark').addClass('btn-success');

// Click get button
		//$('#button-call-import-log-overview').trigger('click');
		$('#updateButton').trigger('click');

}

//=============================================================================
// Set clock
//=============================================================================
function updateClock() {

var currentTime = moment().format('YYYY-MM-DD HH:mm:ss');
	currentTime = REEFT_format_date( currentTime, DFT_DATE_DISPLAY_FORMAT )

$('#input-current-date').val( moment().format('YYYY-MM-DD') );
	$('#input-current-time').val( moment().format('HH:mm:ss') );

$('#current-time').html( currentTime );

// If add mode update date/time in modal window
	if ( $('#input-mode').val() == '*add' )
	{

$('#modal-input-TOK_APPRLS').val( $('#input-current-date').val() );
		$('#modal-input-TOK_ROLE').val( $('#input-current-time').val() );

}

//=============================================================================
// Get data - search
//=============================================================================
function setWebserviceSearch( input_L_STATUSC )
{

// Save curreent webservice name
	$('#input-L_STATUSC').val( input_L_STATUSC );

var selectButtonLineID 		= 'select-button-line-id-' + input_L_STATUSC;

// Set clicked button
	$('.select-button-line').removeClass('btn-success').addClass('btn-dark');
	$('#' + selectButtonLineID).removeClass('btn-dark').addClass('btn-success');

// Search - destory table and start over again
	//$('#REEFTvisual_data').DataTable().clear().destroy();

//$('#REEFTvisual_data').DataTable().destroy();
	//$('#REEFTvisual_data').DataTable().clear().destroy(true);
	$('#REEFTvisual_data').DataTable().clear().destroy();
	setDataTables();

}

//=============================================================================
// jQuery - Ready
//=============================================================================
$(document).ready(function()
{

// When closing modal
	$('#HUB_TKTSTS_maintainModal').on('hidden.bs.modal', function (e) {
		resetModalInputFields();
	})

// Do not show deleted
	$('#input-show-deleted').val('Y');
	$('#input-LASTCALLED').val('<?php echo $LASTCALLED ?>');

$('#delay-marker-id').html('<i id="delay-marker-icon-id" class="text-success fa-solid fa-circle"></i>');

// Get data done by datatables
	setDataTables();

//-----------------------------------------------------------------------
	// Start the clock
	//-----------------------------------------------------------------------
		updateClock();
		setInterval(function() {
			updateClock();
		}, 1000);
	//-----------------------------------------------------------------------

//-----------------------------------------------------------------------
	// Set default from/to date
	//-----------------------------------------------------------------------
		//setDefaultFromToDate('2');
		setDefaultMonths();
	//-----------------------------------------------------------------------

//-----------------------------------------------------------------------
	// Set font awesome icon type
	//-----------------------------------------------------------------------
	// Value is from config/config.php
	var iconType = '<?php echo $DFT_SET_FONT_AWESOME_ICON_TYPE ?>';
	setFontAwesomeIconType( iconType );
	//-----------------------------------------------------------------------

//-----------------------------------------------------------------------
	// Delay keyup checker
	//-----------------------------------------------------------------------
	var delay = (function () {
		var timer = 0;
		return function (callback, ms) {
			clearTimeout(timer);
			timer = setTimeout(callback, ms);
		};
	})()

// DataTable search delay
	//$('#REEFTvisual_data_wrapper .dt-input')
	//$('#REEFTvisual_data_wrapper .dataTables_filter input')
	$('#REEFTvisual_data_wrapper #dt-search-0')
    .unbind() // overrule normal behavior
    .bind('keyup', function(e){

$('#delay-marker-icon-id').removeClass('text-success').addClass('text-danger');

//inputValue = $('.dataTables_filter input').val();
		inputValue = $('#dt-search-0').val();

//=========================================================================================================
	// Set color picker - TEXT
	//
	// Create HEX value (https://en.wikipedia.org/wiki/Web_colors)
	//	var hexValueColor = color.toHexString();
	//
	//	Create RGB (https://en.wikipedia.org/wiki/RGB_color_model)
	//		hexcolor = hexcolor.replace("#", "");
	//		var r = parseInt(hexcolor.substr(0,2),16);
	//		var g = parseInt(hexcolor.substr(2,2),16);
	//		var b = parseInt(hexcolor.substr(4,2),16);
	//		var yiq = ((r*299)+(g*587)+(b*114))/1000;
	//
	//
	//	Create YIQ (https://en.wikipedia.org/wiki/YIQ)
	//		if ( yiq >= 128) {
	//			var textColor = 'black';
	//		} else {
	//			var textColor = 'white';
	//		}
	//
	//	console.log('change: ' + hexcolor + ' ' + hexValueColor + ' ' + yiq + ' ' + r + ' ' + g + ' ' + b );
	//
	//=========================================================================================================
	$(".text-color-palette").spectrum({
		showInitial: true,
		showInput: true,
		chooseText: "Vælg farve",
		cancelText: "Annuller",
		preferredFormat: "hex",
		color: "#000",
		showPalette: true,
		flat: false,
		palette: [
			["#000","#444","#666","#999","#ccc","#eee","#f3f3f3","#fff"],
			["#f00","#f90","#ff0","#0f0","#0ff","#00f","#90f","#f0f"],
			["#f4cccc","#fce5cd","#fff2cc","#d9ead3","#d0e0e3","#cfe2f3","#d9d2e9","#ead1dc"],
			["#ea9999","#f9cb9c","#ffe599","#b6d7a8","#a2c4c9","#9fc5e8","#b4a7d6","#d5a6bd"],
			["#e06666","#f6b26b","#ffd966","#93c47d","#76a5af","#6fa8dc","#8e7cc3","#c27ba0"],
			["#c00","#e69138","#f1c232","#6aa84f","#45818e","#3d85c6","#674ea7","#a64d79"],
			["#900","#b45f06","#bf9000","#38761d","#134f5c","#0b5394","#351c75","#741b47"],
			["#600","#783f04","#7f6000","#274e13","#0c343d","#073763","#20124d","#4c1130"]
		],
		// Called as the original input changes. Only happens when the input is closed or the 'Choose' button is clicked.
		change: function(color) {

// Get hex color
			var hexValueColor = color.toHexString();

},
		move: function(color) {

// Get hex color
			var hexValueColor = color.toHexString();

},
		show: function(color) {

$('#input-current-color-picker').val( this.id );

// Get hex color
			var hexValueColor = color.toHexString();

},
		hide: function(color) {

// Get hex color
			var hexValueColor = color.toHexString();

}
	});

//-----------------------------------------------------------------------
	// Check exists
	//-----------------------------------------------------------------------
	let $filter01 = $('#modal-input-LASTCALLED');
	$filter01.on('keyup', function () {
		delay(function () {
			var inputValue = $('#modal-input-LASTCALLED').val();
			if ( inputValue != '') {
			console.log('this will hit, once user has not typed for 1 second ' + inputValue );
				checkDataExists();
			}
		}, 0800);
	});

//-----------------------------------------------------------------------
	// Event listener for the update button
	//-----------------------------------------------------------------------
    // $('#updateButton').on('click', function() {

// // Trigger a redraw of the table
        // thisGlobalTableData.draw();
    // });

//-----------------------------------------------------------------------
	// Bind the scroll to an element - controls lazy scroll
	//-----------------------------------------------------------------------
	$('#modal-ifs-list-data-result').bind('scroll',chk_scroll);

// Trigger a redraw of the table
        thisGlobalTableData.draw();
    });

//-----------------------------------------------------------------------
	// Set short cuts
	//-----------------------------------------------------------------------

// If add d-none class, do not add shortcut
	if ( GLOBAL_ADD_ALLOWED == 'Y' ) {
		shortcut.add("Alt+F6",function() {
			$('#add-button').click();
		});

// Show add button
		$('#add-button').removeClass('d-none');
	}

// // Close window
	// shortcut.add("Shift+Esc",function() {
		// $('#button-close').click();
	// });

// Make sure scroll is active when closeing the previevwer
	$('#import_done_listIFSfileModal').on("hidden.bs.modal", function (e) { //fire on closing modal box

if ($('.modal:visible').length) { // check whether parent modal is opend after child modal close

$('body').addClass('modal-open'); // if open mean length is 1 then add a bootstrap css class to body of the page

// Remove iframe data...
			//$('#modal-preview-iframe').html('');

}
    });

});
// -->
</script>

</head>

<body>

</div>
		</div>

</div>
			</div>

<div class="container-fluid mt-2 mb-4 d-block d-lg-none">
					<div id="general-message-top" class="border border-danger rounded p-2 text-danger font-weight-boldx"><?php echo $datahub_error0040a ?></div>
				</div>

<div class="d-none d-lg-block">
					<div class="row mb-2">
						<div class="col-12">
							<div id="data-result-button-group"></div>
						</div>
					</div>
				</div>

<div id="from-to-date-wrapper" class="d-none">

</div>

</div>
				</div>

<div class="row mt-2">
					<div class="col-12">
							<div id="data-result" style="width: 100%;"></div>
							<table id="REEFTvisual_data" class="table table-bordered table-striped table-hover">
								<thead>
									<tr class="bg-primary text-white font-weight-bold text-center">
										<th class="text-left"><?php echo $datahub_text0248 ?></th>
										<th class="text-left"><?php echo $datahub_text0149 ?></th>
										<th class="text-left"><?php echo $datahub_text0247 ?></th>
										<th class="text-left"><?php echo $datahub_text0249 ?></th>
										<th class="text-left"><?php echo $datahub_text0250 ?></th>
										<th class="text-left">RMAIN_W_EX</th>
										<th class="text-left">RMAIN_M_EX</th>
										<th class="text-left">NXTTKWEXT1</th>
										<th class="text-left">NXTTKMEXT1</th>
										<th class="text-left">NXTTKWEXT2</th>
										<th class="text-left">NXTTKMEXT2</th>
										<th class="text-left">TOTLIRUNSC</th>
										<th class="text-left">TOTLISTPSC</th>
										<th class="text-left"><?php echo $datahub_text0251 ?></th>
										<th class="text-left"><?php echo $datahub_text0252 ?></th>
										<th class="text-left"><?php echo $datahub_text0253 ?></th>
										<th class="text-left"><?php echo $datahub_text0254 ?></th>
										<th class="text-left"><?php echo $datahub_text0262 ?></th>
										<th class="text-left"><?php echo $datahub_text0077 ?></th>
										<th class="text-left"><button type="button" id="add-button" title="Shortcut: Alt+F6" onclick="dataAdd('0')" class="d-none btn btn-dark btn-block font-weight-bold"><?php echo $datahub_button_save_01 ?></button></th>
										<th class="text-left"></th>
									</tr>
								</thead>
							</table>

</div>
				</div>

</div>

<?php
	include "include/footer.php";
?>

<div class="modal fade" id="HUB_TKTSTS_maintainModal" tabindex="-1" data-backdrop="static" role="dialog" aria-labelledby="HUB_TKTSTS_maintainModalLabel" aria-hidden="true">
  <div class="modal-dialog modal-xxl">
    <div class="modal-content">

</div>
			<div class="col-1 text-right" style="max-width:20px">
				<button type="button" class="close" data-dismiss="modal" aria-label="Close">
				  <span aria-hidden="true">&times;</span>
				</button>
			</div>

</div>
		</div>

</div>

</div>

<hr>

</form>

</div>

</div>
					<div class="col-6 text-right">
					</div>
					<div class="col-3 text-right">
						<button type="button" class="btn btn-primary btn-block" id="buttton-close-modal" data-dismiss="modal"><?php echo $datahub_button_cancel_01 ?></button>
					</div>
				</div>

</div>

</div>
    </div>
  </div>
</div>

<div class="modal fade" id="HUB_TKTSTS_confirmDeleteModal" tabindex="-1" role="dialog" aria-labelledby="HUB_TKTSTS_confirmDeleteModalLabel" aria-hidden="true">
  <div class="modal-dialog modal-xl" role="document">
    <div class="modal-content">
      <div class="modal-header bg-primary text-white">
        <h5 class="modal-title" id="HUB_TKTSTS_confirmDeleteModalLabel"><?php echo $datahub_text0063 ?></h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <div class="modal-body">

</form>

</div>
      <div class="modal-footer">

</div>
      </div>
    </div>
  </div>
</div>

<div class="modal fade" id="import_done_listIFSfileModal" data-keyboard="true" data-backdrop="static" tabindex="-1" role="dialog" aria-labelledby="import_done_listIFSfileModalLabel" aria-hidden="true" style="z-index: 1060;">
  <div class="modal-dialog modal-xxl" role="document">
    <div class="modal-content">
      <div class="modal-header bg-dark text-white" style="background-color:#d8d8d8 !important;color:#000 !important">
        <h6 class="modal-title text-truncate" id="import_done_listIFSfileModalLabel"><i class="font-awesome-pseudo-class fa-thin fa-cloud-arrow-up"></i> <?php echo $datahub_text0204 ?> : <span id="modal-list-current-file"></span></h5>
		<div id="modal-list-download-current-file"></div>
      </div>
      <div class="modal-body">

</div>

</div>
      </div>
    </div>
  </div>
</div>

</body>
</html>